package com.fowo.api.model.tmp.walmart.stock;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ContentStyle;
import com.alibaba.excel.enums.poi.HorizontalAlignmentEnum;
import com.fowo.api.common.excel.ImageConvert;
import com.fowo.api.sys.entity.SysFile;
import java.util.List;
import javax.validation.constraints.*;
import lombok.Getter;
import lombok.Setter;

/** WFS库存临时表 导入导出辅助模型 */
@Getter
@Setter
public class TmpWalmartStockExcelPo {

  @Size(max = 50, message = "GTIN长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "GTIN")
  private String gtin;

  @Size(max = 50, message = "MSKU长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "MSKU")
  private String msku;

  @Size(max = 50, message = "标题长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "标题")
  private String title;

  @Size(max = 50, message = "品牌名称长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "品牌名称")
  private String brandName;

  @Size(max = 50, message = "商品状态长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "商品状态")
  private String platformProductStatus;

  @ExcelProperty(value = "WFS可售")
  private Integer availableQuantity;

  @ExcelProperty(value = "无法入库数量")
  private Integer unabledWarehousingQuantity;

  @ExcelProperty(value = "标发在途")
  private Integer inboundQuantity;

  @ExcelProperty(value = "3个月内库龄")
  private Integer ats03Months;

  @ExcelProperty(value = "3-6个月库龄")
  private Integer ats36Months;

  @ExcelProperty(value = "6-9个月库龄")
  private Integer ats69Months;

  @ExcelProperty(value = "9-12个月库龄")
  private Integer ats912Months;

  @ExcelProperty(value = "12个月以上库龄")
  private Integer ats1Years;

  @ExcelProperty(value = "近30天入库")
  private Integer last30DaysUnitsReceived;

  @ExcelProperty(value = "近30天计划入库")
  private Integer last30DaysPoUnits;

  @ExcelProperty(value = "总库存")
  private Integer quantity;

  @ExcelProperty(value = "本地产品id")
  private Long pid;

  @Size(max = 50, message = "SKU长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "SKU")
  private String sku;

  @Size(max = 1000, message = "品名长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "品名")
  private String productName;

  @ExcelProperty(value = "店铺id")
  private Long sid;

  @Size(max = 50, message = "店铺名长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "店铺名")
  private String shopName;

  @ExcelProperty(value = "图片", converter = ImageConvert.class)
  private List<SysFile> img;
}
